Excel Data Analysis by Paul McFedries

Author:Paul McFedries
Language: eng
Format: epub
Publisher: Wiley
Published: 2013-03-10T16:00:00+00:00

A Excel adds the range to the All References list.

Repeat steps 7 to 9 to add all of the consolidation ranges.

If you have labels in the top row of each range, click the Top Row check box to select it ( changes to ).

If you have labels in the left-column row of each range, click the Left Column check box to select it ( changes to ).

Click OK.

B Excel consolidates the data from the source ranges and displays the summary in the destination range.

APPLY IT

If the layout of the source data changes, then you need to run the consolidation again. If you consolidated by position, then before you can re-run the consolidation, you must first adjust the layout of the consolidation worksheet to match the changes to the source data. (You do not need to do this if you consolidated by category.)

Regardless of the consolidation method you used, before you run the consolidation again, you must delete the existing source ranges. Click the Data tab and then click Consolidate to display the Consolidate dialog box. For each source range, click the range in the All References list and then click Delete.

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.